How to handle null data or empty rows in the excel, as i got no record in mydestination table. Navin.D http://navind.spaces.live.com/

Please post sample data you have in EXCEL file?Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/

Extended http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/9bb8875c-777b-4480-9a31-b5cd479ef62dNavin.D http://navind.spaces.live.com/

Could you use COALESCE to handle NULLs and CASE expression to handle an empty rows?Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/

its excel sheet which i am refering to, i am not sure where should i use themNavin.D http://navind.spaces.live.com/

Hi Navind, By design, the Unpivot transfomation will ignore the column with Null value. In order to output the Null value, we can follow these steps: Add a Deliver Column between the source and the Unpivot transfomation, use this expression "ISNULL([Jan-10]) ? -1 : [Jan-10]" to convert the Null value to -1 firstly. Then, add another Deliver Column between the Unpivot transfomation and the destination, re-convert the -1 to be Null using expression "[Count] == -1 ? NULL(DT_I1) : [Count]" I have implemented a sample package here:http://cid-3c7e963ff6ccd974.office.live.com/self.aspx/.Public/UnPivot.dtsx If you have any more questions, please feel free to ask. Thanks, Jin ChenJin Chen - MSFT